package com.gxa.mapper.cangkumapper;

import com.gxa.pojo.ShangPin;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author zhl
 * @date 2022/4/1 11:23
 */

@Mapper
public interface ShangPinMapper {

    int selectCountshangPin();

    List<ShangPin> selectAllShangPin();

    List<ShangPin> selectAllShangPinForPage(@Param("index") int index, @Param("size") int size);

    List<ShangPin> selectShangPinByshangPinTypeOrshangPinBianHaoOrshangPinMingCheng (@Param("index") int index,@Param("size")int size,
                                                                     @Param("shangPinType") String shangPinType, @Param("guiGeXingHao") String guiGeXingHao,
                                                                     @Param("shangPinMingCheng") String shangPinMingCheng, @Param("unit") String unit,
                                                                     @Param("shangPinBianHao") String shangPinBianHao);






}
